Syntax:
LastDayOfMonth(dateexpr)
Description:
Returns the last day (i.e. Sunday, Monday, etc.) of the month specified
by dateexpr. For
example, this function could return the name of last day of the current
month. The
return integer is one of the following:
ò vbSunday (1) - Sunday
ò vbMonday (2) - Monday
ò vbTuesday (3) - Tuesday
ò vbWednesday (4) - Wednesday
ò vbThursday (5) - Thursday
ò vbFriday (6) - Friday
ò vbSaturday (7) - Saturday
Parameter Description
dateexpr A date which contains the month to be examined
Example:
Sub
Main
'return the name of the last day of this month
lastDayOfTheMonth = LastDayOfTheMonth (Now())
End Sub
See Also